<%@page contentType="text/html" pageEncoding="UTF-8" import="java.io.*, java.sql.*, javax.sql.*"%>
<%
    Connection con = com.elookinto.wordlist.Util.getCon();
    String listName = request.getParameter("listName");
    if (listName ==null) return;
    PreparedStatement st = con.prepareStatement("SELECT distinct link, uid, insert_time from recordlink where listName =? order by insert_time desc ");
    st.setString(1,listName);
    
    ResultSet rs = st.executeQuery();
    while (rs.next()) {
         String link = rs.getString("link");
         String uid = rs.getString("uid");
        //System.out.println(rs.getDate("insert_time"));
        //System.out.println(rs.getString("listname"));
        //System.out.println(rs.getString("uid"));
        //System.out.println(word);
%>

<a style="margin-left:5px" href="<%=link%>" target="audio" ><%= uid %></a>

<%} 
    rs.close();
    st.close();
    con.close();
%>
